package com.besttone.model;

import org.apache.commons.beanutils.converters.IntegerArrayConverter;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.jfinal.plugin.activerecord.Model;
import com.jfinal.plugin.activerecord.Page;

import java.util.List;

/**
 * Created by zhengzhenzhen on 2017/7/19.
 */
public class ScsButton extends Model<ScsButton> {
    private static Log _log = LogFactory.getLog(ScsButton.class);
    public static ScsButton dao = new ScsButton();

    public List<ScsButton> getCntsByDay(String day_id) {
        String select = "select t.product_id,p.product_name,t.channel_no,c.channel_name,t.cnt_uv,t.cnt_pv,t.day_id from ta_security_scsbutton t left join ta_security_product p on t.product_id=p.product_id left join ta_security_channel c on t.channel_no=c.channel_no where t.day_id='"+day_id+"'";
        return dao.use("osp").find(select);
    }


}
